<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@taglib prefix="s"  uri="/struts-tags"%>
<script src="<%=request.getContextPath()%>/ext/TableFilter/tablefilter_all_min.js" language="javascript" type="text/javascript"></script>
<script src="<%=request.getContextPath()%>/ext/TableFilter/sortabletable.js" language="javascript" type="text/javascript"></script>
<script src="<%=request.getContextPath()%>/ext/TableFilter/tfAdapter.sortabletable.js" language="javascript" type="text/javascript"></script>
<link rel="stylesheet" href="<%=request.getContextPath()%>/ext/TableFilter/filtergrid.css">

<style type="text/css" media="screen">
	.myLoader{ 
		position:absolute; padding: 5px 5px 5px 5px;
		margin:100px 0 0 15px; width:auto; 
		z-index:1000; font-size:12px; font-weight:bold;
		border:1px solid #666; background:#ffffcc; 
		vertical-align:middle;
	}
</style>
<title>月贷款利息台账</title><span id="navlink">报表统计 >> 月贷款利息台账</span>

<form action="reportContract" method="get">
借款日期：从
	<input type="text" name="fromdate" class="datepicker" readonly="true" value="${fromdate}"/>到
	<input type="text" name="todate" class="datepicker" readonly="true" value="${todate}"/>
	<input type="submit" id="search" value="查询"/>
	<input type="button" value="报表导出" onclick="location.href='reportContract!reportExport'" />
</form>

<table id="tableDetail" style="width:1400px" cellspacing="0" cellpadding="0">
<tr><th>借款人名称</th><th>次序</th><th>借款日期</th><th>到期日期</th><th>借款金额</th><th>余额</th><th>期限</th><th>利率</th><th>还款日</th>
<th>上个计息日</th><th>计息日</th><th>天数</th><th>应计利息</th>
<th>实收利息</th><th>未收利息</th><th>担保方式</th>
</tr>
<s:iterator value="contractlist" status="index" var="var">
<tr>
<td>${customname}</td>
<td style="text-align:center;width:30px">${grantnum}</td>
<td style="text-align:center;width:100px">${grantdate}</td>
<td style="text-align:center;width:100px">${refunddate}</td>
<td style="text-align:right">${grantmoney}</td>
<td style="text-align:right">${balance}</td>
<td style="text-align:right;width:40px">${dd}天</td>
<td style="text-align:right">${performrates}%</td>
<td style="text-align:center;width:100px">${repaydate}</td>
<td style="text-align:center;width:100px">${lastvaluedate}</td>
<td style="text-align:center;width:100px">${valuedate}</td>
<td style="text-align:right;width:50px">${days}</td>
<td>${interests}</td>
<td>${paidin}</td>
<td>${nopaidin}</td>
<td> 
<s:if test='modeD==1'>抵押 </s:if>
<s:if test='modeZ==1'>质押 </s:if>
<s:if test='modeX==1'>信用 </s:if>
<s:if test='modeB==1'>保证 </s:if>
</td>
</tr>
</s:iterator>
</table>
应收利息 ${sum.sumYingshoulixi}<br />
实收利息 ${sum.sumShishoulixi}<br />
未收利息 ${sum.sumWeishoulixi}<br />
本月发放贷款额<br />
年累计贷款发放${sum.sumJiekuan}<br />
本月收回贷款额
<div id="button_area"></div>


<script type="text/javascript">
<!--

//<![CDATA[	
	var props = {
		sort: true,
		filters_row_index:1,
		remember_grid_values: false,
		alternate_rows: true,
		rows_counter: true,
		rows_counter_text: "显示行数: ",
		btn_reset: true,
		btn_reset_text: "Clear",
		loader: true,
		loader_html: '<img src="<%=request.getContextPath()%>/ext/TableFilter/loader.gif" alt="" ' +
						'style="vertical-align:middle; margin:0 5px 0 5px" />' +
						'<span>Loading...</span>',
		loader_css_class: 'myLoader',
		status_bar: true,
		mark_active_columns: true,
		//col_number_format: [null,null,'US','US','US','US','US','US','US'],
		//col_0: "select",
		col_2: "select",
		col_3: "select",
		col_4: "select",
		col_5: "select",
		col_6: "select",
		col_7: "select",
		col_9: "select",
		col_10: "select",
		col_11: "select",
		col_12: "select",
		col_13: "select",
		col_14: "select",
		col_15: "select",
		display_all_text: "显示所有",
		custom_slc_options: {
			cols:[ 4, 5],
			texts: [
					['0 - 50万','50万 - 100万','100万 - 500万',' 大于 500万 '], 
					['0 - 50万','50万 - 100万','100万 - 500万',' 大于 500万 ']
				],
			values: [
					['>0 && <=500000','>500000 && <=1000000','>1000000 && <=5000000','>5000000'],
					['>0 && <=500000','>500000 && <=1000000','>1000000 && <=5000000','>5000000']
				],
			sorts: [false,false,false,false,false,false,false,false]
		},
		//col_width: ["100px", "50px", "50px","70px","70px","50px","50px","50px","100px","150px", "50px", "70px", "70px", "50px", "70px", "70px"],
		
		//Column resize feature
		extensions: { 	
						name:['ColumnsResizer'], 
						src:['TableFilter/TFExt_ColsResizer/TFExt_ColsResizer.js'], 
						description:['Columns Resizing'], 
						initialize:[function(o){o.SetColsResizer();}]
					},
		col_resizer_all_cells: true
	};
	var tf = setFilterGrid("tableDetail",props);
	
//]]>
//-->
</script>


